J Tech ✭✭✭✭✭

Overview

Overview

Roles	No Roles
Badges	27

About Me

About Me

Not much happening here, yet.

Analytics

74

Posts

120

Visits

9.8k

Points

Aug 17, 2015

Join Date

Jan 15, 2025

Last Active

Reactions

• Insightful 4

  4
• Vote Up 7

  7
• Awesome 4

  4

• Activity
• Discussions12
• Comments62

• Re: Can I use a helper cell to house the year in these formulas?

  J Tech

  03/17/23
  Hi Miranda, The easiest way to do this would be to create the Year field in the sheet summary and replace the 2023 in your formulas to be the sheet summary field.
  2 ·

• Re: Autopopulate 3 columns based on a drop down choice in the 4th

  J Tech

  03/16/23
  Hi Osha, Yes, it's possible to auto-populate columns based on the drop-down selection in Smartsheet. You can try this: Create a new column for each field you want to auto-populate (Admin Assistant Na…
  1 ·

• Re: Change date every week

  J Tech

  03/16/23
  Hi, To automatically update the "Current Week Ending" date every Wednesday to the next upcoming Friday date, you can use the following formula: =IF(WEEKDAY(TODAY(),2)<=3,TODAY()+5,TODAY(…
  1 ·